update Promotion
set PromotionNumber = PromotionNumber - 1
where PromotionNumber > 1
go

update Account
set Account_No = 'Promotion ' + convert(varchar(20), Promotion.PromotionNumber)
from Promotion
where Promotion.PromotionId = Account.PromotionId
go
